CREATE TABLE [dbo].[t_pond_adjust_process] (
    [id] bigint  NOT NULL,
    [pond_id] bigint  NOT NULL,
    [proposer_id] bigint  NOT NULL,
    [approver_id] bigint  NULL,
    [review_id] bigint  NULL,
    [status] int  NOT NULL,
    [old_level] int  NOT NULL,
    [new_level] int  NOT NULL,
    [create_time] datetime  NOT NULL,
    [approver_time] datetime  NULL,
    [review_time] datetime  NULL,
    [is_deleted] int  NOT NULL,
    [cause_str] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
    CONSTRAINT [PK__t_pond_a__3213E83F52DC4355] PRIMARY KEY CLUSTERED ([id])
    WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
    ON [PRIMARY]
    )
    ON [PRIMARY]
    GO

ALTER TABLE [dbo].[t_pond_adjust_process] SET (LOCK_ESCALATION = TABLE)
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'内涝点id',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'pond_id'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'申请人(调整)id',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'proposer_id'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'审批人id',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'approver_id'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'复核人id',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'review_id'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'状态 0待审批 1待复核 2拒绝审批 3拒绝复核 4已结束',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'status'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'原等级',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'old_level'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'新等级',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'new_level'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'创建时间',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'create_time'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'审批时间',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'approver_time'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'复核时间',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'review_time'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'1是0否',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'is_deleted'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'调整原因',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process',
    'COLUMN', N'cause_str'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'积水点等级调整流程表',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond_adjust_process'
